Prerequisites

Database Prerequisites

Important: If the DATABASECHANGELOGLOCK table doesn't exists in the database then the following script should be executed first to create the table.

• Script for the Oracle Database:

  • CREATE TABLE DATABASECHANGELOGLOCK ( ID NUMBER(38) NOT NULL, LOCKED NUMBER(1) NOT NULL,

  LOCKGRANTED TIMESTAMP(6), LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK

  PRIMARY KEY (ID) );

• Script for the SqlServer Database:

  • CREATE TABLE DATABASECHANGELOGLOCK ( ID INT NOT NULL, LOCKED BIT NOT NULL,

  LOCKGRANTED DATETIME, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK

  PRIMARY KEY (ID));

MSSQL Specific Change

Execute the below command to set the compatibility level of the OIPA and IVS databases to 140.

ALTER DATABASE <<database_name>> SET COMPATIBILITY_LEVEL = 140;

Check the compatibility level to make sure its set to 140.

SELECT compatibility_level FROM sys.databases WHERE name = '<<database_name>>';

Note: Replace the actual database name in the above SQL.

Oracle Specific Change

grant CREATE TABLE to <OIPA Username>; (Ignore if already grant was provided)

Note: Replace the actual user name in the above script.

Setup Prerequisites

• The docker must be installed on the host machine.



• By default, the Dockerfiles are configured with Oracle Proxy. Please comment the proxy if you are outside the Oracle network or update it as per your proxy configuration.

  # Comment https_proxy outside the ORACLE network

  ENV https_proxy www-proxy-hqdc.us.oracle.com:80

• Administrative rights to the server.